<?php
session_start();
require_once("db_connect.php");
$thread_contribute_name = array();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet"  href="../css/css.css" type="text/css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.0/jquery.min.js"></script>
<script type="text/javascript" src="../js/jquery.corner.js"></script>
<script type="text/javascript">
	var isLogin = <?php echo array_key_exists("user_id",$_SESSION)?"true":"false"; ?>

	$(document).ready(
		function() {
			$('.box').corner();
			$('.box2').corner();
			$('.box3').corner();
			$('.box4').corner();
			<?php
					echo array_key_exists("error",$_SESSION)?"login_error('".htmlspecialchars($_SESSION['error'],ENT_QUOTES,"UTF-8")."');":"";
					unset($_SESSION["error"]);
				?>
	});
	function writeIn(){
		if($("#thread_title").val()==""){
			alert("タイトルを入力してください。");
			return false;
		}
		if(!isLogin){
			alert('ログインして下さい');
			return false;
		}
	}
	function login_error(error){
		alert(error);
	}
</script>
<title>スレッド一覧</title>
</head>
    <body>
	<div id="container">
		<div id="header" class="box4">
			<div id="header_box" >
				<div id="title">
				</div>
				<div id="search_box">
					<a href="#" id="volunteer">ボランティア</a>｜<a href="#" id="thread">掲示板</a>
					<form method="post" action="search_function/search_display.php?target=volunteer" id="target">
						<input type="text"  name="search_word"><br />
						<input type="submit" value="検索する" id="search_button">
					</form>
				</div>
			</div>
		</div>
		<div id="rightnavi" class="box">
		<?php if(empty($_SESSION["user_name"])&&empty($_SESSION["user_id"])){?>
			<h3>ログインフォーム</h3>
			<form method="post" action="./user_function/UserLogin.php">
				ID：　　<input type="text" name="id" size="10"><br />
				PASS：<input type="text" name="pass" size="10"><br />
				<input style="margin:10px 0 0 39px;" type="image" src="../img/login.png" alt="送信ボタン" name="submit" align="middle">
			</form>
			<a  href="./PHP/User_create.php"><img style="margin:-20px 0 0 39px;" src="../img/newuser.png" border="0"></a>
		<?php }else{?>
				<img src="../img/kaiinlogo.png" id="kaiinlogo" />
				<p>ようこそ<?php echo $_SESSION['nick_name']?>さん！</p>
				<p><a href="./user_function/user_infomation.php">会員情報表示</a></p>
				<p><a href="./user_function/user_update.php">会員情報変更</a></p>
				<p><a href="./user_function/user_display_application.php">申請中ボランティア</a></p>
				<p><a href="./user_function/user_display_volunteer.php">提供中ボランティア</a></p>
				<p><a href="./volunteer_function/volunteer_information_insert.php">ボランティア作成</a></p>
				<p><a href="./user_function/logout.php">ログアウト</a></p>
				<br />
		<?php }?>
		<img src="../img/keizilogo.png" id="keizilogo" />
<ul class="menu_margin">
<div id="thread_title_look">
<?php

	//スレッド項目取得
	$sql = "SELECT t.thread_id,count(thread_name) as thread_count,t.thread_name,max(r.response_date) as response_date,t.thread_id FROM thread AS t LEFT OUTER JOIN response AS r ON t.thread_id = r.thread_id group by t.thread_name order by response_date desc limit 0,5";
	$sth = $db->query($sql);
	if (DB::isError($sth)) {
	  exit($sth->getMessage());
	}

	//スレッド表示
	while ($data = $sth->fetchRow(DB_FETCHMODE_ASSOC)) {
	  echo "<li><a href='response.php?thread_id=".$data['thread_id']."'>";
	  echo mb_strlen($data['thread_name'])>=9?mb_substr($data['thread_name'],0,9)."...":$data['thread_name'];
	  echo "</a></li>";
	}
?>
				</ul>
		<div id="more"><a href="thread.php" >もっと見る...</a></div>
	</div>
<div id="main"  class="box3">
<span id="thread_list">スレッド一覧</span>
<table id="table-01">
<tr>
<th width="30px">NO</th>
<th width="300px">スレッド名</th>
<th width="90px">作成者</th>
<th>コメント数</th>
<th>最終投稿日時</th>
</tr>
<?php
$sql = "SELECT u.nick_name AS nick_name, max( r.response_date ) as response_date FROM response AS r, user AS u WHERE r.user_id = u.user_id GROUP BY r.thread_id ORDER BY response_date DESC;";
$sth = $db->query($sql);
if (DB::isError($sth)) {
  exit($sth->getMessage());
}
//スレッド表示
while ($data = $sth->fetchRow(DB_FETCHMODE_ASSOC)) {
	array_push($thread_contribute_name,$data['nick_name']);
}
//スレッド項目取得
$sql = "SELECT count(thread_name) as thread_count,t.thread_name,max(r.response_date) as response_date,t.thread_id FROM thread AS t LEFT OUTER JOIN response AS r ON t.thread_id = r.thread_id group by t.thread_name order by response_date desc;";
$sth = $db->query($sql);
if (DB::isError($sth)) {
  exit($sth->getMessage());
}
//スレッド表示
$i = 0;
while ($data = $sth->fetchRow(DB_FETCHMODE_ASSOC)) {
  echo "<tr><td>".($i+1)."</td><td><a href='response.php?thread_id=".$data['thread_id']."'>".$data['thread_name']."</a></td><td>".$thread_contribute_name[$i]."</td><td>".$data['thread_count']."</td><td>".$data['response_date']."</td></tr>";
  $i++;
}
?>
</tr>
</table>
<?php
if(array_key_exists("user_id",$_SESSION)){
		echo '<form action="thread_create.php" method="POST" onSubmit="return writeIn()">';
		echo '<span id="thread_title_character">タイトル：</span><input type="text" size="40" name="thread_name"  id="thread_title" /><input type="submit" value="作成" id="thread_submit" /><br />';
		echo '<span id="thread_data_character">内容：</span><br /><textarea rows="10"  cols="65" name="thread_data"  id="thread_data"></textarea><br />';
		echo '</form>';
}
?>
</div>
<div id="space"></div>
</div>
    </body>
</html>